package cn.mapper;

import org.apache.ibatis.jdbc.SQL;



public class TransferProvider {

    public String detailList(Long id){
        return new SQL(){{
            SELECT("tr.* ,su.name operate_name,su.phone operate_phone");
            FROM("transfer tr ");
            LEFT_OUTER_JOIN("sys_user su on tr.oprate_user_id=su.id");
            WHERE("tr.del_flag=0 and tr.work_order_id =#{id} ");
            ORDER_BY(" tr.update_date DESC");
        }}.toString();
    }
}
